Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_WARNING_SETTINGS

`ALL_WARNING_SETTINGS` displays information about the warning parameter settings for the objects accessible to the current user.

Related Views

- `DBA_WARNING_SETTINGS` displays information about the warning parameter settings for all objects in the database.

- `USER_WARNING_SETTINGS` displays information about the warning parameter settings for the objects owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the object
`OBJECT_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the object
`OBJECT_ID` | `NUMBER` | `NOT NULL` | Object number of the object
`OBJECT_TYPE` | `VARCHAR2(12)` |  | Type of the object: `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `TRIGGER` `TYPE` `TYPE BODY`
`WARNING` | `VARCHAR2(40)` |  | Warning number or category: `INFORMATIONAL` `PERFORMANCE` `SEVERE` `ALL`
`SETTING` | `VARCHAR2(7)` |  | Value of the warning setting: `DISABLE` `ENABLE` `ERROR`

See Also: "DBA_WARNING_SETTINGS" "USER_WARNING_SETTINGS"